﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetGuiaRemisionByTipo')
	BEGIN
		DROP  Procedure  GetGuiaRemisionByTipo
	END

GO

CREATE Procedure GetGuiaRemisionByTipo

	(
		@tipo int
	)


AS
begin
SELECT     IdDocumento, 
           IdGuiaRemision, 
           FechaEmision,
           Motivo,
           FechaTranslado,
           Origen, 
           Transporte,
           Destino,
           Descripcion,
           IdEmpleado,
           TipoGuia
FROM       dbo.GuiaRemision
where      TipoGuia=@tipo
end
GO


GRANT EXEC ON GetGuiaRemisionByTipo TO PUBLIC

GO


